Oracle tkprof utility : How to generate and and read
Updated: 2024-10-16 01:42:05
We saw how to enable trace in Oracle in an earlier post. The trace files obtained from the method are in raw form which can be converted into a more readable format using the tkprof utility in Oracle (Transient Kernel PROFile utility) tkprof utility in Oracle The syntax is given below tkprofUsage: tkprof tracefile outputfile …
Oracle tkprof utility : How to generate and and read Read More »
The post Oracle tkprof utility : How to generate and and read appeared first on Techgoeasy.
DAX Query View was created some time ago and it was a great tool to run DAX inside Power BI environment. However, testing a measure in DAX Query View may not be something so obvious. While the measure in a report obeys to the filter context and most of times results in a single value,...…
The post Debugging DAX with DAX Query View appeared first on Simple Talk.
In this article, we look at using SQL Server metadata to better manage SQL code for things like stored procedures, user-defined functions, views, and more.
In this article, we combine multiple columns from an SQL Server table into one column using three different methods to see the most efficient approach.
In this article, learn how to build a Power BI report from start to finish with a real-life example using COVID-related data.
This article examines SQL Server Reporting Services security and what you should know from the Configuration, Web Service, Folder, and Report Level.
Check out this structured reference guide to just about anything you want to know about Power BI and Power BI report development.
Learn some tips and tricks when working with AI/virtual recruiters during the recruitment process and things you should know.
This tip covers executing a Microsoft Fabric query using GraphQL API from an external application, introducing opportunities for data sharing, and exposing data through custom code.
Learn how to implement MySQL on the Azure platform in this step-by-step article using an Azure Database for MySQL flexible server deployment.
Check out this SQL Server stored procedure and function to auto-generate SQL variable coding syntax for many different programming languages.
In this article, we look at how to build an Azure streaming data collection and analysis process to analyze and predict stock prices.
This article will explain Change Management, how DBAs are involved and can benefit from implementing standard processes for all database changes.
Learn how you can export millions of rows of data out of Power BI to either a CSV or Excel file.
Learn how to use the SQL Server Query Store to find CPU-intensive queries and how you can use Query Store to resolve these issues.
Working with XML and T-SQL could be a challenge if you do not know how to access the XML data. In this article, we look at what you need to know to work with XML data in SQL Server.
In this article, we look at how to design a real-time streaming platform that captures data as they are generated and stored in the necessary storage for decision-making.
Learn how to share data currently stored in a Microsoft Fabric warehouse using a GraphQL API along with the steps to set this up.
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.
In this tutorial, we will build an LLM application using LangChain to show you how to start implementing AI in your applications. 
This tip introduces some basic text preprocessing and cleaning techniques with Python that can be used before feeding the data to a machine-learning model. 
This tip covers the differences and similarities between SQL Server index rebuild and index reorganize operations.
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.
In this article, we look at how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.
In this article, we look at a way to capture SQL Server database object changes and an easy way to compare the before and after of these database object changes.
Power BI has been a leading data visualization tool in the market for years. It can be used as a self-service data analysis tool, or as an enterprise-governed business intelligence tool. According to the official website: “Do more with less using an end-to-end BI platform to create a single source of truth, uncover more powerful...…
The post Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster appeared first on Simple Talk.
PostgreSQL has a unique way of dealing with deletes and in this article, we look at the concepts of VACUUM, AUTOVACUUM, and ANALYZE when working with deleted data in a PostgreSQL database.
In this article, we look at how to audit and monitor the use of SQL Server extended stored procedures in your database instance.
I wrote about cloud connections when they were in a very early stage. Cloud connections evolved and are now sharable. We call the “regular” connection as “personal connection”. The problem with the “personal connections” is the difficult to make teamwork. The personal connections belong to you and different developers can’t use them. When a different...…
The post Cloud Connections in Microsoft Fabric appeared first on Simple Talk.
Learn how to build an API using Microsoft Kiota and how popular programming languages like Python can be used to write the API.
In business operations and management, the integration of large Enterprise Resource Planning (ERP) systems has become paramount. As I covered in a previous article, Frappe and ERPNext stand out as powerful tools in this domain, offering comprehensive capabilities for businesses of all sizes. Frappe Framework is also a full-stack web application framework built with Python...…
The post Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part I) appeared first on Simple Talk.
Learn how to build a microservice using the Ocelot API-Gateway in .NET in this step-by-step article.
This tip will introduce and implement the K-Nearest Neighbors model in Python to give you a better understanding of how machine learning works.
In this tip we look at how to use the SQL Server @@ROWCOUNT system variable and things you should know about its usage.
Continuous Integration (CI) and Continuous Delivery (CD) are fundamental to DevOps and agile methodologies. They ensure that software is developed, tested, and delivered quickly and efficiently. CI and CD are more than just trending buzzwords. They are crucial processes that help teams deliver quality software at a high velocity. Understanding CI and CD is essential...…
The post Demystifying Continuous Integration vs. Continuous Delivery: Part 1 appeared first on Simple Talk.
Learn about different ways to improve the performance of full wild card text searches to find strings in SQL Server tables.
This article looks at how to change SQL Server Agent history retention using SQL Server Management Studio GUI and T-SQL scripts.
Learn about the components in the Databricks ecosystem: Dataframes, Spark SQL, SQL Warehouse, Streaming Data, Graph Query Language, and Machine Learning. 
A PASS session intro with Hamish Watson and Saskia Parks PASS Data Community Summit is coming around quickly, and I imagine, like us, you’re all checking out the schedule and highlighting those sessions you’re most interested in. Also like us, you might feel slightly inundated by the sheer number of sessions at events these days...…
The post Future-Proofing Test Data Management: Solutions for DBAs and Developers appeared first on Simple Talk.
In this tutorial, you will learn how to create a message history and a UI for a LangChain chatbot application.